/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80015
 Source Host           : 127.0.0.1:3306
 Source Schema         : ehotel

 Target Server Type    : MySQL
 Target Server Version : 80015
 File Encoding         : 65001

 Date: 29/05/2019 13:38:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (4, 'Can add group', 2, 'add_group');
INSERT INTO `auth_permission` VALUES (5, 'Can change group', 2, 'change_group');
INSERT INTO `auth_permission` VALUES (6, 'Can delete group', 2, 'delete_group');
INSERT INTO `auth_permission` VALUES (7, 'Can add permission', 3, 'add_permission');
INSERT INTO `auth_permission` VALUES (8, 'Can change permission', 3, 'change_permission');
INSERT INTO `auth_permission` VALUES (9, 'Can delete permission', 3, 'delete_permission');
INSERT INTO `auth_permission` VALUES (10, 'Can add content type', 4, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (11, 'Can change content type', 4, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (12, 'Can delete content type', 4, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (13, 'Can add session', 5, 'add_session');
INSERT INTO `auth_permission` VALUES (14, 'Can change session', 5, 'change_session');
INSERT INTO `auth_permission` VALUES (15, 'Can delete session', 5, 'delete_session');
INSERT INTO `auth_permission` VALUES (16, 'Can add 用户信息', 6, 'add_userprofile');
INSERT INTO `auth_permission` VALUES (17, 'Can change 用户信息', 6, 'change_userprofile');
INSERT INTO `auth_permission` VALUES (18, 'Can delete 用户信息', 6, 'delete_userprofile');
INSERT INTO `auth_permission` VALUES (19, 'Can add 房间信息', 7, 'add_room');
INSERT INTO `auth_permission` VALUES (20, 'Can change 房间信息', 7, 'change_room');
INSERT INTO `auth_permission` VALUES (21, 'Can delete 房间信息', 7, 'delete_room');
INSERT INTO `auth_permission` VALUES (22, 'Can add 房间类型', 8, 'add_roomtype');
INSERT INTO `auth_permission` VALUES (23, 'Can change 房间类型', 8, 'change_roomtype');
INSERT INTO `auth_permission` VALUES (24, 'Can delete 房间类型', 8, 'delete_roomtype');
INSERT INTO `auth_permission` VALUES (25, 'Can add 订单', 9, 'add_hotelorder');
INSERT INTO `auth_permission` VALUES (26, 'Can change 订单', 9, 'change_hotelorder');
INSERT INTO `auth_permission` VALUES (27, 'Can delete 订单', 9, 'delete_hotelorder');
INSERT INTO `auth_permission` VALUES (28, 'Can add customer', 10, 'add_customer');
INSERT INTO `auth_permission` VALUES (29, 'Can change customer', 10, 'change_customer');
INSERT INTO `auth_permission` VALUES (30, 'Can delete customer', 10, 'delete_customer');
INSERT INTO `auth_permission` VALUES (31, 'Can add hot time', 11, 'add_hottime');
INSERT INTO `auth_permission` VALUES (32, 'Can change hot time', 11, 'change_hottime');
INSERT INTO `auth_permission` VALUES (33, 'Can delete hot time', 11, 'delete_hottime');
COMMIT;

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_users_userprofile_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_users_userprofile_id` FOREIGN KEY (`user_id`) REFERENCES `users_userprofile` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` VALUES (2, 'auth', 'group');
INSERT INTO `django_content_type` VALUES (3, 'auth', 'permission');
INSERT INTO `django_content_type` VALUES (4, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` VALUES (9, 'operation', 'hotelorder');
INSERT INTO `django_content_type` VALUES (11, 'room', 'hottime');
INSERT INTO `django_content_type` VALUES (7, 'room', 'room');
INSERT INTO `django_content_type` VALUES (8, 'room', 'roomtype');
INSERT INTO `django_content_type` VALUES (5, 'sessions', 'session');
INSERT INTO `django_content_type` VALUES (10, 'users', 'customer');
INSERT INTO `django_content_type` VALUES (6, 'users', 'userprofile');
COMMIT;

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2019-04-15 05:48:35.854544');
INSERT INTO `django_migrations` VALUES (2, 'contenttypes', '0002_remove_content_type_name', '2019-04-15 05:48:35.914019');
INSERT INTO `django_migrations` VALUES (3, 'auth', '0001_initial', '2019-04-15 05:48:36.063580');
INSERT INTO `django_migrations` VALUES (4, 'auth', '0002_alter_permission_name_max_length', '2019-04-15 05:48:36.099390');
INSERT INTO `django_migrations` VALUES (5, 'auth', '0003_alter_user_email_max_length', '2019-04-15 05:48:36.110985');
INSERT INTO `django_migrations` VALUES (6, 'auth', '0004_alter_user_username_opts', '2019-04-15 05:48:36.122191');
INSERT INTO `django_migrations` VALUES (7, 'auth', '0005_alter_user_last_login_null', '2019-04-15 05:48:36.134387');
INSERT INTO `django_migrations` VALUES (8, 'auth', '0006_require_contenttypes_0002', '2019-04-15 05:48:36.144622');
INSERT INTO `django_migrations` VALUES (9, 'auth', '0007_alter_validators_add_error_messages', '2019-04-15 05:48:36.156753');
INSERT INTO `django_migrations` VALUES (10, 'auth', '0008_alter_user_username_max_length', '2019-04-15 05:48:36.168731');
INSERT INTO `django_migrations` VALUES (11, 'users', '0001_initial', '2019-04-15 05:48:36.387045');
INSERT INTO `django_migrations` VALUES (12, 'admin', '0001_initial', '2019-04-15 05:48:36.475923');
INSERT INTO `django_migrations` VALUES (13, 'admin', '0002_logentry_remove_auto_add', '2019-04-15 05:48:36.509117');
INSERT INTO `django_migrations` VALUES (14, 'sessions', '0001_initial', '2019-04-15 05:48:36.541597');
INSERT INTO `django_migrations` VALUES (15, 'users', '0002_auto_20190415_1855', '2019-04-15 10:55:59.816791');
INSERT INTO `django_migrations` VALUES (16, 'users', '0003_userprofile_id_card', '2019-04-15 11:05:59.376509');
INSERT INTO `django_migrations` VALUES (17, 'users', '0004_auto_20190415_1905', '2019-04-15 11:05:59.440340');
INSERT INTO `django_migrations` VALUES (18, 'users', '0005_remove_userprofile_image', '2019-04-15 11:06:31.621249');
INSERT INTO `django_migrations` VALUES (19, 'users', '0006_userprofile_age', '2019-04-15 12:21:00.114295');
INSERT INTO `django_migrations` VALUES (20, 'room', '0001_initial', '2019-04-19 06:20:06.090329');
INSERT INTO `django_migrations` VALUES (21, 'room', '0002_room_num', '2019-04-19 06:33:18.639355');
INSERT INTO `django_migrations` VALUES (22, 'operation', '0001_initial', '2019-04-19 13:19:15.627804');
INSERT INTO `django_migrations` VALUES (23, 'operation', '0002_hotelorder_room_num', '2019-04-21 05:37:17.167744');
INSERT INTO `django_migrations` VALUES (24, 'operation', '0003_hotelorder_room_type', '2019-04-21 05:39:43.588442');
INSERT INTO `django_migrations` VALUES (25, 'operation', '0004_auto_20190421_1402', '2019-04-21 06:02:45.404353');
INSERT INTO `django_migrations` VALUES (26, 'operation', '0005_auto_20190421_1403', '2019-04-21 06:03:13.968232');
INSERT INTO `django_migrations` VALUES (27, 'operation', '0006_hotelorder_money', '2019-04-23 19:00:47.877004');
INSERT INTO `django_migrations` VALUES (28, 'users', '0007_customer', '2019-04-24 14:39:30.092576');
INSERT INTO `django_migrations` VALUES (29, 'room', '0003_room_is_book', '2019-04-27 16:25:08.485112');
INSERT INTO `django_migrations` VALUES (30, 'room', '0004_room_time', '2019-04-28 14:25:22.423810');
INSERT INTO `django_migrations` VALUES (31, 'room', '0005_hottime', '2019-05-25 19:22:52.342807');
INSERT INTO `django_migrations` VALUES (32, 'room', '0006_auto_20190525_1944', '2019-05-25 19:44:57.294929');
COMMIT;

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_session
-- ----------------------------
BEGIN;
INSERT INTO `django_session` VALUES ('2tjx3dx05j4eylmrc6cbkespns5e9d8h', 'ZWIxMGRiNjk0YTY3Y2M5NWIyOTQ3MzMyNTFjNmU5MmJiYTBiYjc3MTp7Il9hdXRoX3VzZXJfaGFzaCI6ImNkYWE4MDZjMjBjZDlmYjIxNDc3M2I1MzdlZmI5OTIxZWJjNmNiY2MiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJ1c2Vycy52aWV3cy5DdXN0b21CYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjEifQ==', '2019-05-31 15:03:07.028235');
INSERT INTO `django_session` VALUES ('59xpk5p0n6z1othdw34986pqau3kbqon', 'N2M1NzBhM2I3MzAxYjNhYjg2ZjJmOGYyNGUxM2Q2M2Q4N2Y3MWFjZTp7fQ==', '2019-04-29 06:02:39.811241');
INSERT INTO `django_session` VALUES ('6d5yobt6lyxhr44uor2pv1e1plvoa5vh', 'N2M1NzBhM2I3MzAxYjNhYjg2ZjJmOGYyNGUxM2Q2M2Q4N2Y3MWFjZTp7fQ==', '2019-04-29 06:03:36.278490');
INSERT INTO `django_session` VALUES ('gmhdz86o43g2xmpofwgzmfleoucoamno', 'ZmEwNGZkZWZiMjRiZDkxNTMzNjQ4MjU5MTI0OGJkZGY2YmYwMzIxNjp7Il9hdXRoX3VzZXJfaGFzaCI6IjJkMDdjYzg2ZmVmYzJiYjQ1YTg0NjQzMmYzMDFlZWFiYzI3MTQ5N2UiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJ1c2Vycy52aWV3cy5DdXN0b21CYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjEifQ==', '2019-04-29 11:07:32.533076');
INSERT INTO `django_session` VALUES ('gt472hcnc1yxmkk65dyxk0cj70z4nsmn', 'ZWIxMGRiNjk0YTY3Y2M5NWIyOTQ3MzMyNTFjNmU5MmJiYTBiYjc3MTp7Il9hdXRoX3VzZXJfaGFzaCI6ImNkYWE4MDZjMjBjZDlmYjIxNDc3M2I1MzdlZmI5OTIxZWJjNmNiY2MiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJ1c2Vycy52aWV3cy5DdXN0b21CYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjEifQ==', '2019-05-23 22:59:45.407074');
INSERT INTO `django_session` VALUES ('rq3va9o2xi4gnoxtc05lxwccs8btqdbz', 'NzU5NDA1N2FhYmNiOWJiMDk0N2NhMzg2ZTEyOTFjODVlYzYxZTk0Njp7Il9hdXRoX3VzZXJfaGFzaCI6ImRkMzJlMzY4MDE1MGMxZDYzNWY5ZTI5NGY3MGNlYjIyMGJjN2JhZjgiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJ1c2Vycy52aWV3cy5DdXN0b21CYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjIifQ==', '2019-05-10 22:33:57.072598');
INSERT INTO `django_session` VALUES ('sxe34w8ddnbhfhuxf6j7lr3bk989a8ow', 'NzU5NDA1N2FhYmNiOWJiMDk0N2NhMzg2ZTEyOTFjODVlYzYxZTk0Njp7Il9hdXRoX3VzZXJfaGFzaCI6ImRkMzJlMzY4MDE1MGMxZDYzNWY5ZTI5NGY3MGNlYjIyMGJjN2JhZjgiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJ1c2Vycy52aWV3cy5DdXN0b21CYWNrZW5kIiwiX2F1dGhfdXNlcl9pZCI6IjIifQ==', '2019-05-12 00:37:25.711095');
COMMIT;

-- ----------------------------
-- Table structure for operation_hotelorder
-- ----------------------------
DROP TABLE IF EXISTS `operation_hotelorder`;
CREATE TABLE `operation_hotelorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `id_card` varchar(18) NOT NULL,
  `people_num` int(11) NOT NULL,
  `mobile` varchar(11) NOT NULL,
  `s_time` datetime(6) NOT NULL,
  `e_time` datetime(6) NOT NULL,
  `type` int(11) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `room_num` int(11) NOT NULL,
  `room_type` varchar(20) NOT NULL,
  `money` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of operation_hotelorder
-- ----------------------------
BEGIN;
INSERT INTO `operation_hotelorder` VALUES (22, '张三', '123467878909878902', 2, '13627897891', '2019-04-24 00:00:00.000000', '2019-04-25 00:00:00.000000', 3, 'male', 1001, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (23, '李四', '238978656789876234', 1, '15567890234', '2019-04-25 00:00:00.000000', '2019-04-26 00:00:00.000000', 3, 'male', 1002, '4', '190');
INSERT INTO `operation_hotelorder` VALUES (24, '王刚', '123456734567892345', 2, '13245678453', '2019-04-24 00:00:00.000000', '2019-04-26 00:00:00.000000', 3, 'male', 1004, '2', '300');
INSERT INTO `operation_hotelorder` VALUES (25, '孙雨', '234567892334567890', 2, '13524345678', '2019-04-24 00:00:00.000000', '2019-04-25 00:00:00.000000', 3, 'male', 1011, '2', '150');
INSERT INTO `operation_hotelorder` VALUES (26, '黎明', '234789678908767890', 2, '18723445347', '2019-04-24 00:00:00.000000', '2019-04-26 00:00:00.000000', 3, 'male', 2010, '4', '380');
INSERT INTO `operation_hotelorder` VALUES (27, '李放', '234789456378928736', 2, '15923465429', '2019-04-25 00:00:00.000000', '2019-04-26 00:00:00.000000', 3, 'male', 1005, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (28, '葫芦', '23333322', 2, '322222222', '2019-04-26 00:00:00.000000', '2019-04-27 00:00:00.000000', 3, 'male', 1004, '2', '150');
INSERT INTO `operation_hotelorder` VALUES (29, '张亮', '2333443243222', 2, '33333333', '2019-04-26 00:00:00.000000', '2019-04-27 00:00:00.000000', 3, 'male', 1003, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (30, '刘明', '233333333333333333', 2, '123144424', '2019-04-27 00:00:00.000000', '2019-04-30 00:00:00.000000', 1, 'male', 3005, '3', '480');
INSERT INTO `operation_hotelorder` VALUES (31, '李浩', '111111111111111111', 1, '12345678943', '2019-04-28 00:00:00.000000', '2019-04-29 00:00:00.000000', 3, 'male', 1001, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (32, '刘凯', '222222222222223', 1, '1112312213', '2019-04-28 00:00:00.000000', '2019-04-29 00:00:00.000000', 3, 'male', 1001, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (33, '大陆', ' 12313123', 2, '1231341412', '2019-04-28 00:00:00.000000', '2019-04-29 00:00:00.000000', 3, 'male', 1012, '3', '160');
INSERT INTO `operation_hotelorder` VALUES (34, '经开', '2333111111', 1, '', '2019-04-28 00:00:00.000000', '2019-04-30 00:00:00.000000', 3, 'male', 1004, '2', '300');
INSERT INTO `operation_hotelorder` VALUES (35, '搭嘎', '2333333343433', 1, '13424234', '2019-04-29 12:00:00.000000', '2019-04-30 12:00:00.000000', 2, 'male', 1003, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (36, '龙卷风', '3243242342342', 1, '123142414', '2019-04-28 14:18:26.825314', '2019-04-29 12:00:00.000000', 1, 'male', 1007, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (37, '安抚', '23324433432445', 1, '141412443', '2019-04-29 12:00:00.000000', '2019-04-30 12:00:00.000000', 2, 'male', 1004, '2', '150');
INSERT INTO `operation_hotelorder` VALUES (38, '科技', '1122222222112', 1, '1233331424', '2019-04-28 14:56:48.517749', '2019-04-30 12:00:00.000000', 1, 'male', 1002, '4', '380');
INSERT INTO `operation_hotelorder` VALUES (39, '士大夫', '132214124124', 1, '123124412', '2019-04-28 14:57:20.420362', '2019-04-29 12:00:00.000000', 1, 'male', 3004, '2', '150');
INSERT INTO `operation_hotelorder` VALUES (40, '电饭锅', '12313412134144', 1, '1231314421', '2019-04-29 12:00:00.000000', '2019-04-30 12:00:00.000000', 3, 'male', 1011, '2', '150');
INSERT INTO `operation_hotelorder` VALUES (41, '梨花', '12142345341', 22, '1123141', '2019-05-06 19:06:45.081067', '2019-05-07 12:00:00.000000', 1, 'male', 1005, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (42, '激活', '121341412', 2, '132144', '2019-05-03 19:08:12.356539', '2019-05-05 12:00:00.000000', 1, 'male', 1003, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (43, '12313', '12314124', 2, '14321414', '2019-05-01 19:10:17.835701', '2019-05-02 12:00:00.000000', 1, 'male', 1006, '1', '250');
INSERT INTO `operation_hotelorder` VALUES (44, '六天', '23424242', 1, '1421412', '2019-05-09 21:57:28.912252', '2019-05-10 12:00:00.000000', 1, 'male', 2001, '4', '190');
INSERT INTO `operation_hotelorder` VALUES (45, '看就', '2342354252', 1, '12414211', '2019-05-11 12:00:00.000000', '2019-05-12 12:00:00.000000', 2, 'male', 1007, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (46, '大范德萨', '113244', 2, '123412412', '2019-05-14 13:38:31.625745', '2019-05-15 12:00:00.000000', 1, 'male', 1003, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (47, '额外若无', '12321412412', 1, '214124124', '2019-05-14 13:38:53.589575', '2019-05-15 12:00:00.000000', 1, 'male', 1012, '3', '160');
INSERT INTO `operation_hotelorder` VALUES (48, '沙发', '12415423523', 1, '1323131', '2019-05-16 12:00:00.000000', '2019-05-17 12:00:00.000000', 3, 'male', 1002, '4', '190');
INSERT INTO `operation_hotelorder` VALUES (49, '人文氛围', '123414', 2, '321412', '2019-05-15 12:00:00.000000', '2019-05-16 12:00:00.000000', 3, 'male', 1005, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (50, '大士大夫', '13224235235', 1, '14124124', '2019-05-18 12:00:00.000000', '2019-05-20 12:00:00.000000', 3, 'male', 1002, '4', '380');
INSERT INTO `operation_hotelorder` VALUES (51, '理发', '234242', 2, '1234141', '2019-05-17 12:00:00.000000', '2019-05-18 12:00:00.000000', 1, 'male', 1003, '1', '125');
INSERT INTO `operation_hotelorder` VALUES (52, '特委托任务', '23424234', 1, '1231412215', '2019-05-17 12:00:00.000000', '2019-05-19 12:00:00.000000', 2, 'male', 1012, '3', '320');
INSERT INTO `operation_hotelorder` VALUES (53, '大士大夫	', '13224235235', 1, '14124124', '2019-05-24 14:11:37.721798', '2019-05-25 12:00:00.000000', 3, 'male', 1001, '1', '125');
COMMIT;

-- ----------------------------
-- Table structure for room_hottime
-- ----------------------------
DROP TABLE IF EXISTS `room_hottime`;
CREATE TABLE `room_hottime` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_num` int(11) NOT NULL,
  `s_time` datetime(6) NOT NULL,
  `e_time` datetime(6) NOT NULL,
  `price` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of room_hottime
-- ----------------------------
BEGIN;
INSERT INTO `room_hottime` VALUES (2, 3, '2019-05-25 12:00:00.000000', '2019-05-29 12:00:00.000000', '200');
INSERT INTO `room_hottime` VALUES (3, 1, '2019-05-26 12:00:00.000000', '2019-05-30 12:00:00.000000', '300');
COMMIT;

-- ----------------------------
-- Table structure for room_room
-- ----------------------------
DROP TABLE IF EXISTS `room_room`;
CREATE TABLE `room_room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `floor` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `people_num` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `num` varchar(10) NOT NULL,
  `is_book` int(11) NOT NULL,
  `time` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of room_room
-- ----------------------------
BEGIN;
INSERT INTO `room_room` VALUES (1, 1, 1, 2, 1, '1001', 1, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (2, 1, 1, 2, 4, '1002', 1, '2019-05-18 00:00:00.000000');
INSERT INTO `room_room` VALUES (3, 1, 1, 2, 1, '1003', 1, '2019-05-17 00:00:00.000000');
INSERT INTO `room_room` VALUES (4, 1, 1, 2, 2, '1004', 1, '2019-04-28 14:32:50.898563');
INSERT INTO `room_room` VALUES (5, 1, 1, 2, 1, '1005', 1, '2019-05-15 00:00:00.000000');
INSERT INTO `room_room` VALUES (6, 1, 1, 2, 1, '1006', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (7, 1, 1, 2, 1, '1007', 1, '2019-05-11 00:00:00.000000');
INSERT INTO `room_room` VALUES (8, 1, 1, 2, 1, '1008', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (9, 1, 4, 2, 1, '1009', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (10, 1, 1, 2, 1, '1010', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (11, 1, 1, 2, 2, '1011', 1, '2019-04-29 00:00:00.000000');
INSERT INTO `room_room` VALUES (12, 1, 1, 2, 3, '1012', 1, '2019-05-17 00:00:00.000000');
INSERT INTO `room_room` VALUES (13, 2, 1, 2, 4, '2001', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (14, 2, 1, 2, 3, '2002', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (15, 2, 1, 2, 2, '2003', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (16, 2, 1, 2, 2, '2004', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (17, 2, 4, 2, 3, '2005', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (18, 2, 1, 2, 4, '2006', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (19, 2, 1, 2, 2, '2007', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (20, 2, 1, 2, 3, '2008', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (21, 2, 1, 2, 4, '2009', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (22, 2, 1, 2, 4, '2010', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (23, 2, 1, 2, 1, '2011', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (24, 2, 1, 2, 1, '2012', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (25, 3, 1, 2, 1, '3001', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (26, 3, 1, 2, 1, '3002', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (27, 3, 1, 3, 2, '3003', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (28, 3, 1, 2, 2, '3004', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (29, 3, 1, 2, 3, '3005', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (30, 3, 1, 4, 4, '3006', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (31, 3, 1, 2, 3, '3007', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (32, 3, 1, 2, 4, '3008', 0, '2019-04-28 14:25:22.345341');
INSERT INTO `room_room` VALUES (33, 1, 1, 4, 1, '3009', 0, '2019-04-28 14:25:22.345341');
COMMIT;

-- ----------------------------
-- Table structure for room_roomtype
-- ----------------------------
DROP TABLE IF EXISTS `room_roomtype`;
CREATE TABLE `room_roomtype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `type_num` int(11) NOT NULL,
  `price` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of room_roomtype
-- ----------------------------
BEGIN;
INSERT INTO `room_roomtype` VALUES (1, '标准间', 1, '125');
INSERT INTO `room_roomtype` VALUES (2, '大床房', 2, '150');
INSERT INTO `room_roomtype` VALUES (3, '商务双人间', 3, '160');
INSERT INTO `room_roomtype` VALUES (4, '豪华大床房', 4, '190');
COMMIT;

-- ----------------------------
-- Table structure for users_customer
-- ----------------------------
DROP TABLE IF EXISTS `users_customer`;
CREATE TABLE `users_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `mobile` varchar(11) DEFAULT NULL,
  `id_card` varchar(18) DEFAULT NULL,
  `rant` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of users_customer
-- ----------------------------
BEGIN;
INSERT INTO `users_customer` VALUES (3, '李放', 'male', '1232143213', '234789456378928736', 2);
INSERT INTO `users_customer` VALUES (4, '葫芦', 'male', '322222222', '23333322', 1);
INSERT INTO `users_customer` VALUES (5, '张亮', 'male', '33333333', '2333443243222', 4);
INSERT INTO `users_customer` VALUES (6, '刘明', 'male', '123144424', '233333333333333333', 4);
INSERT INTO `users_customer` VALUES (7, '李浩', 'male', '12345678943', '111111111111111111', 4);
INSERT INTO `users_customer` VALUES (8, '刘凯', 'male', '1112312213', '222222222222223', 4);
INSERT INTO `users_customer` VALUES (9, '大陆', 'male', '1231341412', ' 12313123', 4);
INSERT INTO `users_customer` VALUES (11, '搭嘎', 'male', '13424234', '2333333343433', 4);
INSERT INTO `users_customer` VALUES (12, '龙卷风', 'male', '123142414', '3243242342342', 4);
INSERT INTO `users_customer` VALUES (13, '安抚', 'male', '141412443', '23324433432445', 4);
INSERT INTO `users_customer` VALUES (14, '科技', 'male', '1233331424', '1122222222112', 4);
INSERT INTO `users_customer` VALUES (15, '士大夫', 'male', '123124412', '132214124124', 4);
INSERT INTO `users_customer` VALUES (16, '电饭锅', 'male', '1231314421', '12313412134144', 4);
INSERT INTO `users_customer` VALUES (17, '梨花', 'male', '1123141', '12142345341', 4);
INSERT INTO `users_customer` VALUES (18, '激活', 'male', '132144', '121341412', 4);
INSERT INTO `users_customer` VALUES (19, '12313', 'male', '14321414', '12314124', 4);
INSERT INTO `users_customer` VALUES (20, '六天', 'male', '1421412', '23424242', 4);
INSERT INTO `users_customer` VALUES (21, '看就', 'male', '12414211', '2342354252', 4);
INSERT INTO `users_customer` VALUES (22, '大范德萨', 'male', '123412412', '113244', 4);
INSERT INTO `users_customer` VALUES (23, '额外若无', 'male', '214124124', '12321412412', 4);
INSERT INTO `users_customer` VALUES (24, '沙发', 'male', '1323131', '12415423523', 4);
INSERT INTO `users_customer` VALUES (25, '人文氛围', 'male', '321412', '123414', 4);
INSERT INTO `users_customer` VALUES (26, '大士大夫', 'male', '14124124', '13224235235', 4);
INSERT INTO `users_customer` VALUES (27, '理发', 'male', '1234141', '234242', 4);
INSERT INTO `users_customer` VALUES (28, '特委托任务', 'male', '1231412215', '23424234', 4);
COMMIT;

-- ----------------------------
-- Table structure for users_userprofile
-- ----------------------------
DROP TABLE IF EXISTS `users_userprofile`;
CREATE TABLE `users_userprofile` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `nick_name` varchar(50) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `birday` date DEFAULT NULL,
  `mobile` varchar(11) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `type` int(11) NOT NULL,
  `id_card` varchar(18) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of users_userprofile
-- ----------------------------
BEGIN;
INSERT INTO `users_userprofile` VALUES (1, 'pbkdf2_sha256$36000$vFjljnGRkAyu$6NcF2lorMHNiB2WIPLSyhAO55MjH2LB03s4rnHpc9Q8=', '2019-05-17 15:03:07.018229', 1, 'admin', '', '', '123456@qq.com', 1, 1, '2019-04-15 05:50:43.853984', '', 'male', NULL, '1234556789', NULL, 0, '1234445511', 28);
INSERT INTO `users_userprofile` VALUES (2, 'pbkdf2_sha256$36000$7MdjadWQ9PLA$kr1p2M+ilT5TmIbFMxXLCrOv0BlYBZNzZfNbDylr460=', '2019-04-28 00:37:25.703063', 0, '111111', '', '', '111111@qq.com', 0, 1, '2019-04-15 12:35:00.875156', '', 'male', NULL, '111111', NULL, 2, '12344', 30);
INSERT INTO `users_userprofile` VALUES (3, 'pbkdf2_sha256$36000$Of94DX3Td3bw$Vb/2YWz3RgLdKBJ6ReZmcTK7xSdtzvsn83Rq5jeYdPQ=', NULL, 0, '222222', '', '', '222222@qq.com', 0, 1, '2019-04-19 05:47:08.712519', '', 'female', NULL, '222222', NULL, 2, '1222222222222', 22);
INSERT INTO `users_userprofile` VALUES (21, 'pbkdf2_sha256$36000$uTazsZ3rVXO1$FPRjKQ3WbxveeBkZFvODieU3JP83gCRFgz1b1jxp0Qk=', NULL, 0, '123131', '', '', '321312312@qq.com', 0, 1, '2019-04-25 22:58:54.492885', '', 'female', NULL, '3213123', NULL, 2, '31231312', 21);
INSERT INTO `users_userprofile` VALUES (22, 'pbkdf2_sha256$36000$j82OXLHaT0ag$gHijDRubqdIDIdfRVr5pgOAGzuDd6nUEkhoNhFQLrN0=', NULL, 0, '666666', '', '', '666666@qq.com', 0, 1, '2019-04-26 15:42:18.923071', '', 'female', NULL, '6666666', NULL, 1, '66666666666666', 26);
INSERT INTO `users_userprofile` VALUES (23, 'pbkdf2_sha256$36000$tgoZhmLPFpG0$zxf0ZIj/gQQ1JxfCmckMqO2EJVzMEKtJC2xv8//WKtk=', NULL, 0, '777777', '', '', '777777@qq.com', 0, 1, '2019-04-26 16:02:46.277751', '', 'female', NULL, '777777', NULL, 2, '777777777', 24);
INSERT INTO `users_userprofile` VALUES (24, 'pbkdf2_sha256$36000$OfY2gCkOKuHJ$l+XBeK6ikZSZnyB1rz0r2uPef0lUUefzwORrOu3Nblc=', NULL, 0, '888888', '', '', '888888@qq.com', 0, 1, '2019-04-26 16:06:24.867859', '', 'female', NULL, '888888888', NULL, 4, '888888888888', 39);
COMMIT;

-- ----------------------------
-- Table structure for users_userprofile_groups
-- ----------------------------
DROP TABLE IF EXISTS `users_userprofile_groups`;
CREATE TABLE `users_userprofile_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userprofile_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_userprofile_groups_userprofile_id_group_id_823cf2fc_uniq` (`userprofile_id`,`group_id`),
  KEY `users_userprofile_groups_group_id_3de53dbf_fk_auth_group_id` (`group_id`),
  CONSTRAINT `users_userprofile_gr_userprofile_id_a4496a80_fk_users_use` FOREIGN KEY (`userprofile_id`) REFERENCES `users_userprofile` (`id`),
  CONSTRAINT `users_userprofile_groups_group_id_3de53dbf_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Table structure for users_userprofile_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `users_userprofile_user_permissions`;
CREATE TABLE `users_userprofile_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userprofile_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_userprofile_user_p_userprofile_id_permissio_d0215190_uniq` (`userprofile_id`,`permission_id`),
  KEY `users_userprofile_us_permission_id_393136b6_fk_auth_perm` (`permission_id`),
  CONSTRAINT `users_userprofile_us_permission_id_393136b6_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `users_userprofile_us_userprofile_id_34544737_fk_users_use` FOREIGN KEY (`userprofile_id`) REFERENCES `users_userprofile` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

SET FOREIGN_KEY_CHECKS = 1;
